home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Libris Britannia 4
/
science library(b).zip
/
science library(b)
/
PROGRAMM
/
DB_CLIPP
/
0264.ZIP
/
CHKBK.ARC
/
CHKBOOK.DOC
< prev
next >
Wrap
Text File
|
1985-07-23
|
6KB
|
134 lines
Electronic Checkbook
A dBase III Application
by Daniel J. Collins
Introduction:
Electronic Checkbook is a dBase application program. There are
very few features of dBase III used in this program that do not
exist in dBase II, so it would be a simple task to use this program
under dBase II. This program was developed for use as a teaching
model in a dBase Programming Language course that I teach. It
therefore utilizes many different programming techniques and is a
basic dBase "Tour de Force". This program is supplied free of
charge with the following provisions:
* You may not remove my copyright notice from the source code.
* You may not change the name of the program and distribute
copies with this new name.
* All copies of this program you distribute must be accompanied
by this document.
* This program is provided free of charge under the FREEWARE
concept. If you find it of use you are requested to forward a
donation of $10.00 to:
Daniel J. Collins
197 Tenth Avenue
New York, NY 10011
Overview:
Electronic Checkbook is designed to keep accurate track of all
checks written, all deposits made and reconcile both to your
monthly statement. It consists of two databases; one for checks,
another for deposits. Both databases are indexed. The program
itself consists of a small main menu program (CHKBOOK.PRG) and a
larger procedure file (SUBROUTE.PRG). NOTE: The procedure file
is too long to edit with the dBase III editor. If you wish to
modify the program you MUST use a text editor such as Wordstar in
non-document mode. Failure to do so will result in the last two
subroutines being lost which will cause the program to bomb
during the main menu. The system also includes two standard
report files (CHKS.FRM and DEPS.FRM) which are used in various
report commands. Feel free to modify these reports, they are
very simple.
Getting started:
To begin using the Electronic Checkbook you must first run a
program called INITIAL.PRG. Simply boot dBase III and after
setting your default drive and/or path properly, type: DO
INITIAL. This program loads some graphic characters from a
memory file (BOX.MEM) and adds the startup data for your system.
I have included a program called BOXMAKER.PRG for your review,
it creates the memory variable file BOX.MEM (you do not need to
run this program). You will be prompted for an account name (up
to 70 characters), an account number (up to 20 characters) and
an opening balance (up to $9,999,999.99). You will have an
opportunity to confirm that the data is correct and if not,
re-enter it. If you confirm the data, a new memory file is
created (DATA.MEM) and you are returned to the "dot prompt". You
will no longer need INITIAL.PRG or BOX.MEM unless you wish to
restart the system or start a new system.
The balance of your account is not stored in the database itself,
but rather as a running balance in memory. It is saved to disk
only at the completion of a session. Therfore, ESCAPE is set to
off at the beginning of the program. This means you will not be
able to terminate the program once it is begun, except by exiting
from the menu.
Selecting "Enter deposits" from the main menu allows you to enter
deposits to the system. You may enter interest amounts by simply
entering them as any other deposit and answering "Y"es to the
"Cleared? (Y/N)" prompt.
Entering checks is done in a similar manner, except that for the
first check entered at each session the date will default to the
current system date and the check number will default to 1. For
all subsequent entry, however, the date will carry forward and
the check number will increment by 1. Again, service charges and
ATM withdrwals may entered without a check number and by marking
the check cleared.
At all times the current balance will be displayed at the top of
the screen. A negative balance is indicated by parentheses.
Monthly statements can be reconciled very easily. When prompted,
simply enter check numbers and deposit amounts and if they exist
and have not already been cleared, they will be cleared. This
dialogue is followed by a screen that displays the current
balance, the total of outstanding checks, the total of
outstanding deposits and what should be the balance shown on your
statement.
Summary reports are also available and are executed by simply
following the screen prompts. These are setup to run to the
printer, so be sure you have a printer connected and ready to
print or else your system will hang.
Special notes:
The file CHKBOOK.PRG contains a set color command. Comment this
line out or delete it if you are using a monochrome monitor. This
progarm CAN be edited with the dBase editor.
Always enter interest amounts using the current date. Deposits
are indexed by date during entry and you could end up placing a
new entry into the middle of your database, throwing off the
account balance.
Both data entry screens use format files (CHECK.FMT and DEP.FMT)
to position data on the screen.
CHECKS.DBF contains a MEMO field. This field may contain up to
4096 characters. If you do not wish to use it, you may modify
the database structure and the format file. This will speed up
the system slightly.
If you encounter any severe problems or bugs in this program
please contact me:
Daniel J. Collins
Source ID: TCL638
Compuserve ID: 72065,241
or on the CURA BBS in NYC.